from openpyxl import Workbook

workbook = Workbook()
sheet = workbook.active

first_row = ['门店', '数量']
sheet.append(first_row)

from faker import Faker
from random import randint

faker = Faker(locale='zh_CN')  # 中文的生成假数据的对象
for i in range(5):
    values = [faker.company(), randint(0, 1000)]  # 门店 数量
    sheet.append(values)
# 保存
workbook.save('03门店服务数量.xlsx')
